Mybatis+clickhouse 动态SQL的update和insert不好使这件事 | 您所在的位置:网站首页 › mybatis w3c › Mybatis+clickhouse 动态SQL的update和insert不好使这件事 |
文章目录 不好使替代方法 不好使 insert用法 @Insert("" +
" insert " +
" into tableName (column1, column2, column3)" +
" values (#{value1}, #{value2}, #{value3}) " +
""}
)void insertValues(@Param("value1") type value1, @Param("value2") type value2, @Param("value3") type value3);
update用法 @Update("" +
" update " +
" tableName " +
" " +
" " +
" tableName.value1 = #{value1} " +
" " +
" " +
" " +
" " +
" tableName.value2 = #{value2} " +
" " +
" " +
" and tableName.value3 in" +
" " +
" #{value} " +
" " +
" " +
" " +
"where id=#{id}",
""}
)void updateValues(@Param("value1") type value1, @Param("value2") type value2, @Param("value3") List value3);
参考 替代方法 insert List batchArgs = new ArrayLists(); Object[] args = { value1, value2, value3 }; batchArgs.add(args); String sql = "insert into tableName (column1, column2, column3)" + "values (?, ?, ?)"; jdbcTemplate.batchUpdate(sql, batchArgs); update 更改sql语句为update语句即可另jdbcTemplate.batchUpdate参数还有其他几种情况 参考 |
CopyRight 2018-2019 实验室设备网 版权所有 |